SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_participantsUnitPassedcounts]
	
	(
	@param_id int 
	)
	
AS
	/* SET NOCOUNT ON */
	select count(*) fromJOL_Recruitment_Participants_apply as a inner join JOL_Recruitment as bon a.recruitment = b.idwhere b.id=@param_id AND a.[state]='True'
	RETURN
GO
